package com.model;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class OrderExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public OrderExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("ID is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("ID is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Long value) {
            addCriterion("ID =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Long value) {
            addCriterion("ID <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Long value) {
            addCriterion("ID >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Long value) {
            addCriterion("ID >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Long value) {
            addCriterion("ID <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Long value) {
            addCriterion("ID <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Long> values) {
            addCriterion("ID in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Long> values) {
            addCriterion("ID not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Long value1, Long value2) {
            addCriterion("ID between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Long value1, Long value2) {
            addCriterion("ID not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andUseridIsNull() {
            addCriterion("UserID is null");
            return (Criteria) this;
        }

        public Criteria andUseridIsNotNull() {
            addCriterion("UserID is not null");
            return (Criteria) this;
        }

        public Criteria andUseridEqualTo(Long value) {
            addCriterion("UserID =", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotEqualTo(Long value) {
            addCriterion("UserID <>", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridGreaterThan(Long value) {
            addCriterion("UserID >", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridGreaterThanOrEqualTo(Long value) {
            addCriterion("UserID >=", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLessThan(Long value) {
            addCriterion("UserID <", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLessThanOrEqualTo(Long value) {
            addCriterion("UserID <=", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridIn(List<Long> values) {
            addCriterion("UserID in", values, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotIn(List<Long> values) {
            addCriterion("UserID not in", values, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridBetween(Long value1, Long value2) {
            addCriterion("UserID between", value1, value2, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotBetween(Long value1, Long value2) {
            addCriterion("UserID not between", value1, value2, "userid");
            return (Criteria) this;
        }

        public Criteria andOrdernoIsNull() {
            addCriterion("OrderNO is null");
            return (Criteria) this;
        }

        public Criteria andOrdernoIsNotNull() {
            addCriterion("OrderNO is not null");
            return (Criteria) this;
        }

        public Criteria andOrdernoEqualTo(String value) {
            addCriterion("OrderNO =", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoNotEqualTo(String value) {
            addCriterion("OrderNO <>", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoGreaterThan(String value) {
            addCriterion("OrderNO >", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoGreaterThanOrEqualTo(String value) {
            addCriterion("OrderNO >=", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoLessThan(String value) {
            addCriterion("OrderNO <", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoLessThanOrEqualTo(String value) {
            addCriterion("OrderNO <=", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoLike(String value) {
            addCriterion("OrderNO like", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoNotLike(String value) {
            addCriterion("OrderNO not like", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoIn(List<String> values) {
            addCriterion("OrderNO in", values, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoNotIn(List<String> values) {
            addCriterion("OrderNO not in", values, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoBetween(String value1, String value2) {
            addCriterion("OrderNO between", value1, value2, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoNotBetween(String value1, String value2) {
            addCriterion("OrderNO not between", value1, value2, "orderno");
            return (Criteria) this;
        }

        public Criteria andMoneyIsNull() {
            addCriterion("Money is null");
            return (Criteria) this;
        }

        public Criteria andMoneyIsNotNull() {
            addCriterion("Money is not null");
            return (Criteria) this;
        }

        public Criteria andMoneyEqualTo(BigDecimal value) {
            addCriterion("Money =", value, "money");
            return (Criteria) this;
        }

        public Criteria andMoneyNotEqualTo(BigDecimal value) {
            addCriterion("Money <>", value, "money");
            return (Criteria) this;
        }

        public Criteria andMoneyGreaterThan(BigDecimal value) {
            addCriterion("Money >", value, "money");
            return (Criteria) this;
        }

        public Criteria andMoneyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("Money >=", value, "money");
            return (Criteria) this;
        }

        public Criteria andMoneyLessThan(BigDecimal value) {
            addCriterion("Money <", value, "money");
            return (Criteria) this;
        }

        public Criteria andMoneyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("Money <=", value, "money");
            return (Criteria) this;
        }

        public Criteria andMoneyIn(List<BigDecimal> values) {
            addCriterion("Money in", values, "money");
            return (Criteria) this;
        }

        public Criteria andMoneyNotIn(List<BigDecimal> values) {
            addCriterion("Money not in", values, "money");
            return (Criteria) this;
        }

        public Criteria andMoneyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Money between", value1, value2, "money");
            return (Criteria) this;
        }

        public Criteria andMoneyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Money not between", value1, value2, "money");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("Status is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("Status is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(Integer value) {
            addCriterion("Status =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(Integer value) {
            addCriterion("Status <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(Integer value) {
            addCriterion("Status >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("Status >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(Integer value) {
            addCriterion("Status <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(Integer value) {
            addCriterion("Status <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<Integer> values) {
            addCriterion("Status in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<Integer> values) {
            addCriterion("Status not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(Integer value1, Integer value2) {
            addCriterion("Status between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("Status not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andTypeIsNull() {
            addCriterion("Type is null");
            return (Criteria) this;
        }

        public Criteria andTypeIsNotNull() {
            addCriterion("Type is not null");
            return (Criteria) this;
        }

        public Criteria andTypeEqualTo(Integer value) {
            addCriterion("Type =", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotEqualTo(Integer value) {
            addCriterion("Type <>", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeGreaterThan(Integer value) {
            addCriterion("Type >", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("Type >=", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeLessThan(Integer value) {
            addCriterion("Type <", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeLessThanOrEqualTo(Integer value) {
            addCriterion("Type <=", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeIn(List<Integer> values) {
            addCriterion("Type in", values, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotIn(List<Integer> values) {
            addCriterion("Type not in", values, "type");
            return (Criteria) this;
        }

        public Criteria andTypeBetween(Integer value1, Integer value2) {
            addCriterion("Type between", value1, value2, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("Type not between", value1, value2, "type");
            return (Criteria) this;
        }

        public Criteria andAgentselleridIsNull() {
            addCriterion("AgentSellerID is null");
            return (Criteria) this;
        }

        public Criteria andAgentselleridIsNotNull() {
            addCriterion("AgentSellerID is not null");
            return (Criteria) this;
        }

        public Criteria andAgentselleridEqualTo(Integer value) {
            addCriterion("AgentSellerID =", value, "agentsellerid");
            return (Criteria) this;
        }

        public Criteria andAgentselleridNotEqualTo(Integer value) {
            addCriterion("AgentSellerID <>", value, "agentsellerid");
            return (Criteria) this;
        }

        public Criteria andAgentselleridGreaterThan(Integer value) {
            addCriterion("AgentSellerID >", value, "agentsellerid");
            return (Criteria) this;
        }

        public Criteria andAgentselleridGreaterThanOrEqualTo(Integer value) {
            addCriterion("AgentSellerID >=", value, "agentsellerid");
            return (Criteria) this;
        }

        public Criteria andAgentselleridLessThan(Integer value) {
            addCriterion("AgentSellerID <", value, "agentsellerid");
            return (Criteria) this;
        }

        public Criteria andAgentselleridLessThanOrEqualTo(Integer value) {
            addCriterion("AgentSellerID <=", value, "agentsellerid");
            return (Criteria) this;
        }

        public Criteria andAgentselleridIn(List<Integer> values) {
            addCriterion("AgentSellerID in", values, "agentsellerid");
            return (Criteria) this;
        }

        public Criteria andAgentselleridNotIn(List<Integer> values) {
            addCriterion("AgentSellerID not in", values, "agentsellerid");
            return (Criteria) this;
        }

        public Criteria andAgentselleridBetween(Integer value1, Integer value2) {
            addCriterion("AgentSellerID between", value1, value2, "agentsellerid");
            return (Criteria) this;
        }

        public Criteria andAgentselleridNotBetween(Integer value1, Integer value2) {
            addCriterion("AgentSellerID not between", value1, value2, "agentsellerid");
            return (Criteria) this;
        }

        public Criteria andAgentmoneyIsNull() {
            addCriterion("AgentMoney is null");
            return (Criteria) this;
        }

        public Criteria andAgentmoneyIsNotNull() {
            addCriterion("AgentMoney is not null");
            return (Criteria) this;
        }

        public Criteria andAgentmoneyEqualTo(BigDecimal value) {
            addCriterion("AgentMoney =", value, "agentmoney");
            return (Criteria) this;
        }

        public Criteria andAgentmoneyNotEqualTo(BigDecimal value) {
            addCriterion("AgentMoney <>", value, "agentmoney");
            return (Criteria) this;
        }

        public Criteria andAgentmoneyGreaterThan(BigDecimal value) {
            addCriterion("AgentMoney >", value, "agentmoney");
            return (Criteria) this;
        }

        public Criteria andAgentmoneyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("AgentMoney >=", value, "agentmoney");
            return (Criteria) this;
        }

        public Criteria andAgentmoneyLessThan(BigDecimal value) {
            addCriterion("AgentMoney <", value, "agentmoney");
            return (Criteria) this;
        }

        public Criteria andAgentmoneyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("AgentMoney <=", value, "agentmoney");
            return (Criteria) this;
        }

        public Criteria andAgentmoneyIn(List<BigDecimal> values) {
            addCriterion("AgentMoney in", values, "agentmoney");
            return (Criteria) this;
        }

        public Criteria andAgentmoneyNotIn(List<BigDecimal> values) {
            addCriterion("AgentMoney not in", values, "agentmoney");
            return (Criteria) this;
        }

        public Criteria andAgentmoneyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("AgentMoney between", value1, value2, "agentmoney");
            return (Criteria) this;
        }

        public Criteria andAgentmoneyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("AgentMoney not between", value1, value2, "agentmoney");
            return (Criteria) this;
        }

        public Criteria andLogisticsIsNull() {
            addCriterion("Logistics is null");
            return (Criteria) this;
        }

        public Criteria andLogisticsIsNotNull() {
            addCriterion("Logistics is not null");
            return (Criteria) this;
        }

        public Criteria andLogisticsEqualTo(Long value) {
            addCriterion("Logistics =", value, "logistics");
            return (Criteria) this;
        }

        public Criteria andLogisticsNotEqualTo(Long value) {
            addCriterion("Logistics <>", value, "logistics");
            return (Criteria) this;
        }

        public Criteria andLogisticsGreaterThan(Long value) {
            addCriterion("Logistics >", value, "logistics");
            return (Criteria) this;
        }

        public Criteria andLogisticsGreaterThanOrEqualTo(Long value) {
            addCriterion("Logistics >=", value, "logistics");
            return (Criteria) this;
        }

        public Criteria andLogisticsLessThan(Long value) {
            addCriterion("Logistics <", value, "logistics");
            return (Criteria) this;
        }

        public Criteria andLogisticsLessThanOrEqualTo(Long value) {
            addCriterion("Logistics <=", value, "logistics");
            return (Criteria) this;
        }

        public Criteria andLogisticsIn(List<Long> values) {
            addCriterion("Logistics in", values, "logistics");
            return (Criteria) this;
        }

        public Criteria andLogisticsNotIn(List<Long> values) {
            addCriterion("Logistics not in", values, "logistics");
            return (Criteria) this;
        }

        public Criteria andLogisticsBetween(Long value1, Long value2) {
            addCriterion("Logistics between", value1, value2, "logistics");
            return (Criteria) this;
        }

        public Criteria andLogisticsNotBetween(Long value1, Long value2) {
            addCriterion("Logistics not between", value1, value2, "logistics");
            return (Criteria) this;
        }

        public Criteria andLogisticsmoneyIsNull() {
            addCriterion("LogisticsMoney is null");
            return (Criteria) this;
        }

        public Criteria andLogisticsmoneyIsNotNull() {
            addCriterion("LogisticsMoney is not null");
            return (Criteria) this;
        }

        public Criteria andLogisticsmoneyEqualTo(BigDecimal value) {
            addCriterion("LogisticsMoney =", value, "logisticsmoney");
            return (Criteria) this;
        }

        public Criteria andLogisticsmoneyNotEqualTo(BigDecimal value) {
            addCriterion("LogisticsMoney <>", value, "logisticsmoney");
            return (Criteria) this;
        }

        public Criteria andLogisticsmoneyGreaterThan(BigDecimal value) {
            addCriterion("LogisticsMoney >", value, "logisticsmoney");
            return (Criteria) this;
        }

        public Criteria andLogisticsmoneyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("LogisticsMoney >=", value, "logisticsmoney");
            return (Criteria) this;
        }

        public Criteria andLogisticsmoneyLessThan(BigDecimal value) {
            addCriterion("LogisticsMoney <", value, "logisticsmoney");
            return (Criteria) this;
        }

        public Criteria andLogisticsmoneyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("LogisticsMoney <=", value, "logisticsmoney");
            return (Criteria) this;
        }

        public Criteria andLogisticsmoneyIn(List<BigDecimal> values) {
            addCriterion("LogisticsMoney in", values, "logisticsmoney");
            return (Criteria) this;
        }

        public Criteria andLogisticsmoneyNotIn(List<BigDecimal> values) {
            addCriterion("LogisticsMoney not in", values, "logisticsmoney");
            return (Criteria) this;
        }

        public Criteria andLogisticsmoneyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("LogisticsMoney between", value1, value2, "logisticsmoney");
            return (Criteria) this;
        }

        public Criteria andLogisticsmoneyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("LogisticsMoney not between", value1, value2, "logisticsmoney");
            return (Criteria) this;
        }

        public Criteria andLogisticsnoIsNull() {
            addCriterion("LogisticsNO is null");
            return (Criteria) this;
        }

        public Criteria andLogisticsnoIsNotNull() {
            addCriterion("LogisticsNO is not null");
            return (Criteria) this;
        }

        public Criteria andLogisticsnoEqualTo(String value) {
            addCriterion("LogisticsNO =", value, "logisticsno");
            return (Criteria) this;
        }

        public Criteria andLogisticsnoNotEqualTo(String value) {
            addCriterion("LogisticsNO <>", value, "logisticsno");
            return (Criteria) this;
        }

        public Criteria andLogisticsnoGreaterThan(String value) {
            addCriterion("LogisticsNO >", value, "logisticsno");
            return (Criteria) this;
        }

        public Criteria andLogisticsnoGreaterThanOrEqualTo(String value) {
            addCriterion("LogisticsNO >=", value, "logisticsno");
            return (Criteria) this;
        }

        public Criteria andLogisticsnoLessThan(String value) {
            addCriterion("LogisticsNO <", value, "logisticsno");
            return (Criteria) this;
        }

        public Criteria andLogisticsnoLessThanOrEqualTo(String value) {
            addCriterion("LogisticsNO <=", value, "logisticsno");
            return (Criteria) this;
        }

        public Criteria andLogisticsnoLike(String value) {
            addCriterion("LogisticsNO like", value, "logisticsno");
            return (Criteria) this;
        }

        public Criteria andLogisticsnoNotLike(String value) {
            addCriterion("LogisticsNO not like", value, "logisticsno");
            return (Criteria) this;
        }

        public Criteria andLogisticsnoIn(List<String> values) {
            addCriterion("LogisticsNO in", values, "logisticsno");
            return (Criteria) this;
        }

        public Criteria andLogisticsnoNotIn(List<String> values) {
            addCriterion("LogisticsNO not in", values, "logisticsno");
            return (Criteria) this;
        }

        public Criteria andLogisticsnoBetween(String value1, String value2) {
            addCriterion("LogisticsNO between", value1, value2, "logisticsno");
            return (Criteria) this;
        }

        public Criteria andLogisticsnoNotBetween(String value1, String value2) {
            addCriterion("LogisticsNO not between", value1, value2, "logisticsno");
            return (Criteria) this;
        }

        public Criteria andLogisticscompanyIsNull() {
            addCriterion("LogisticsCompany is null");
            return (Criteria) this;
        }

        public Criteria andLogisticscompanyIsNotNull() {
            addCriterion("LogisticsCompany is not null");
            return (Criteria) this;
        }

        public Criteria andLogisticscompanyEqualTo(String value) {
            addCriterion("LogisticsCompany =", value, "logisticscompany");
            return (Criteria) this;
        }

        public Criteria andLogisticscompanyNotEqualTo(String value) {
            addCriterion("LogisticsCompany <>", value, "logisticscompany");
            return (Criteria) this;
        }

        public Criteria andLogisticscompanyGreaterThan(String value) {
            addCriterion("LogisticsCompany >", value, "logisticscompany");
            return (Criteria) this;
        }

        public Criteria andLogisticscompanyGreaterThanOrEqualTo(String value) {
            addCriterion("LogisticsCompany >=", value, "logisticscompany");
            return (Criteria) this;
        }

        public Criteria andLogisticscompanyLessThan(String value) {
            addCriterion("LogisticsCompany <", value, "logisticscompany");
            return (Criteria) this;
        }

        public Criteria andLogisticscompanyLessThanOrEqualTo(String value) {
            addCriterion("LogisticsCompany <=", value, "logisticscompany");
            return (Criteria) this;
        }

        public Criteria andLogisticscompanyLike(String value) {
            addCriterion("LogisticsCompany like", value, "logisticscompany");
            return (Criteria) this;
        }

        public Criteria andLogisticscompanyNotLike(String value) {
            addCriterion("LogisticsCompany not like", value, "logisticscompany");
            return (Criteria) this;
        }

        public Criteria andLogisticscompanyIn(List<String> values) {
            addCriterion("LogisticsCompany in", values, "logisticscompany");
            return (Criteria) this;
        }

        public Criteria andLogisticscompanyNotIn(List<String> values) {
            addCriterion("LogisticsCompany not in", values, "logisticscompany");
            return (Criteria) this;
        }

        public Criteria andLogisticscompanyBetween(String value1, String value2) {
            addCriterion("LogisticsCompany between", value1, value2, "logisticscompany");
            return (Criteria) this;
        }

        public Criteria andLogisticscompanyNotBetween(String value1, String value2) {
            addCriterion("LogisticsCompany not between", value1, value2, "logisticscompany");
            return (Criteria) this;
        }

        public Criteria andStoreidIsNull() {
            addCriterion("StoreID is null");
            return (Criteria) this;
        }

        public Criteria andStoreidIsNotNull() {
            addCriterion("StoreID is not null");
            return (Criteria) this;
        }

        public Criteria andStoreidEqualTo(Integer value) {
            addCriterion("StoreID =", value, "storeid");
            return (Criteria) this;
        }

        public Criteria andStoreidNotEqualTo(Integer value) {
            addCriterion("StoreID <>", value, "storeid");
            return (Criteria) this;
        }

        public Criteria andStoreidGreaterThan(Integer value) {
            addCriterion("StoreID >", value, "storeid");
            return (Criteria) this;
        }

        public Criteria andStoreidGreaterThanOrEqualTo(Integer value) {
            addCriterion("StoreID >=", value, "storeid");
            return (Criteria) this;
        }

        public Criteria andStoreidLessThan(Integer value) {
            addCriterion("StoreID <", value, "storeid");
            return (Criteria) this;
        }

        public Criteria andStoreidLessThanOrEqualTo(Integer value) {
            addCriterion("StoreID <=", value, "storeid");
            return (Criteria) this;
        }

        public Criteria andStoreidIn(List<Integer> values) {
            addCriterion("StoreID in", values, "storeid");
            return (Criteria) this;
        }

        public Criteria andStoreidNotIn(List<Integer> values) {
            addCriterion("StoreID not in", values, "storeid");
            return (Criteria) this;
        }

        public Criteria andStoreidBetween(Integer value1, Integer value2) {
            addCriterion("StoreID between", value1, value2, "storeid");
            return (Criteria) this;
        }

        public Criteria andStoreidNotBetween(Integer value1, Integer value2) {
            addCriterion("StoreID not between", value1, value2, "storeid");
            return (Criteria) this;
        }

        public Criteria andLeavelmessageIsNull() {
            addCriterion("LeavelMessage is null");
            return (Criteria) this;
        }

        public Criteria andLeavelmessageIsNotNull() {
            addCriterion("LeavelMessage is not null");
            return (Criteria) this;
        }

        public Criteria andLeavelmessageEqualTo(String value) {
            addCriterion("LeavelMessage =", value, "leavelmessage");
            return (Criteria) this;
        }

        public Criteria andLeavelmessageNotEqualTo(String value) {
            addCriterion("LeavelMessage <>", value, "leavelmessage");
            return (Criteria) this;
        }

        public Criteria andLeavelmessageGreaterThan(String value) {
            addCriterion("LeavelMessage >", value, "leavelmessage");
            return (Criteria) this;
        }

        public Criteria andLeavelmessageGreaterThanOrEqualTo(String value) {
            addCriterion("LeavelMessage >=", value, "leavelmessage");
            return (Criteria) this;
        }

        public Criteria andLeavelmessageLessThan(String value) {
            addCriterion("LeavelMessage <", value, "leavelmessage");
            return (Criteria) this;
        }

        public Criteria andLeavelmessageLessThanOrEqualTo(String value) {
            addCriterion("LeavelMessage <=", value, "leavelmessage");
            return (Criteria) this;
        }

        public Criteria andLeavelmessageLike(String value) {
            addCriterion("LeavelMessage like", value, "leavelmessage");
            return (Criteria) this;
        }

        public Criteria andLeavelmessageNotLike(String value) {
            addCriterion("LeavelMessage not like", value, "leavelmessage");
            return (Criteria) this;
        }

        public Criteria andLeavelmessageIn(List<String> values) {
            addCriterion("LeavelMessage in", values, "leavelmessage");
            return (Criteria) this;
        }

        public Criteria andLeavelmessageNotIn(List<String> values) {
            addCriterion("LeavelMessage not in", values, "leavelmessage");
            return (Criteria) this;
        }

        public Criteria andLeavelmessageBetween(String value1, String value2) {
            addCriterion("LeavelMessage between", value1, value2, "leavelmessage");
            return (Criteria) this;
        }

        public Criteria andLeavelmessageNotBetween(String value1, String value2) {
            addCriterion("LeavelMessage not between", value1, value2, "leavelmessage");
            return (Criteria) this;
        }

        public Criteria andDescriptionIsNull() {
            addCriterion("Description is null");
            return (Criteria) this;
        }

        public Criteria andDescriptionIsNotNull() {
            addCriterion("Description is not null");
            return (Criteria) this;
        }

        public Criteria andDescriptionEqualTo(String value) {
            addCriterion("Description =", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionNotEqualTo(String value) {
            addCriterion("Description <>", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionGreaterThan(String value) {
            addCriterion("Description >", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionGreaterThanOrEqualTo(String value) {
            addCriterion("Description >=", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionLessThan(String value) {
            addCriterion("Description <", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionLessThanOrEqualTo(String value) {
            addCriterion("Description <=", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionLike(String value) {
            addCriterion("Description like", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionNotLike(String value) {
            addCriterion("Description not like", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionIn(List<String> values) {
            addCriterion("Description in", values, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionNotIn(List<String> values) {
            addCriterion("Description not in", values, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionBetween(String value1, String value2) {
            addCriterion("Description between", value1, value2, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionNotBetween(String value1, String value2) {
            addCriterion("Description not between", value1, value2, "description");
            return (Criteria) this;
        }

        public Criteria andConsigneeIsNull() {
            addCriterion("Consignee is null");
            return (Criteria) this;
        }

        public Criteria andConsigneeIsNotNull() {
            addCriterion("Consignee is not null");
            return (Criteria) this;
        }

        public Criteria andConsigneeEqualTo(String value) {
            addCriterion("Consignee =", value, "consignee");
            return (Criteria) this;
        }

        public Criteria andConsigneeNotEqualTo(String value) {
            addCriterion("Consignee <>", value, "consignee");
            return (Criteria) this;
        }

        public Criteria andConsigneeGreaterThan(String value) {
            addCriterion("Consignee >", value, "consignee");
            return (Criteria) this;
        }

        public Criteria andConsigneeGreaterThanOrEqualTo(String value) {
            addCriterion("Consignee >=", value, "consignee");
            return (Criteria) this;
        }

        public Criteria andConsigneeLessThan(String value) {
            addCriterion("Consignee <", value, "consignee");
            return (Criteria) this;
        }

        public Criteria andConsigneeLessThanOrEqualTo(String value) {
            addCriterion("Consignee <=", value, "consignee");
            return (Criteria) this;
        }

        public Criteria andConsigneeLike(String value) {
            addCriterion("Consignee like", value, "consignee");
            return (Criteria) this;
        }

        public Criteria andConsigneeNotLike(String value) {
            addCriterion("Consignee not like", value, "consignee");
            return (Criteria) this;
        }

        public Criteria andConsigneeIn(List<String> values) {
            addCriterion("Consignee in", values, "consignee");
            return (Criteria) this;
        }

        public Criteria andConsigneeNotIn(List<String> values) {
            addCriterion("Consignee not in", values, "consignee");
            return (Criteria) this;
        }

        public Criteria andConsigneeBetween(String value1, String value2) {
            addCriterion("Consignee between", value1, value2, "consignee");
            return (Criteria) this;
        }

        public Criteria andConsigneeNotBetween(String value1, String value2) {
            addCriterion("Consignee not between", value1, value2, "consignee");
            return (Criteria) this;
        }

        public Criteria andPhoneIsNull() {
            addCriterion("Phone is null");
            return (Criteria) this;
        }

        public Criteria andPhoneIsNotNull() {
            addCriterion("Phone is not null");
            return (Criteria) this;
        }

        public Criteria andPhoneEqualTo(String value) {
            addCriterion("Phone =", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneNotEqualTo(String value) {
            addCriterion("Phone <>", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneGreaterThan(String value) {
            addCriterion("Phone >", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneGreaterThanOrEqualTo(String value) {
            addCriterion("Phone >=", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneLessThan(String value) {
            addCriterion("Phone <", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneLessThanOrEqualTo(String value) {
            addCriterion("Phone <=", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneLike(String value) {
            addCriterion("Phone like", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneNotLike(String value) {
            addCriterion("Phone not like", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneIn(List<String> values) {
            addCriterion("Phone in", values, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneNotIn(List<String> values) {
            addCriterion("Phone not in", values, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneBetween(String value1, String value2) {
            addCriterion("Phone between", value1, value2, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneNotBetween(String value1, String value2) {
            addCriterion("Phone not between", value1, value2, "phone");
            return (Criteria) this;
        }

        public Criteria andPostcodeIsNull() {
            addCriterion("Postcode is null");
            return (Criteria) this;
        }

        public Criteria andPostcodeIsNotNull() {
            addCriterion("Postcode is not null");
            return (Criteria) this;
        }

        public Criteria andPostcodeEqualTo(String value) {
            addCriterion("Postcode =", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeNotEqualTo(String value) {
            addCriterion("Postcode <>", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeGreaterThan(String value) {
            addCriterion("Postcode >", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeGreaterThanOrEqualTo(String value) {
            addCriterion("Postcode >=", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeLessThan(String value) {
            addCriterion("Postcode <", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeLessThanOrEqualTo(String value) {
            addCriterion("Postcode <=", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeLike(String value) {
            addCriterion("Postcode like", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeNotLike(String value) {
            addCriterion("Postcode not like", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeIn(List<String> values) {
            addCriterion("Postcode in", values, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeNotIn(List<String> values) {
            addCriterion("Postcode not in", values, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeBetween(String value1, String value2) {
            addCriterion("Postcode between", value1, value2, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeNotBetween(String value1, String value2) {
            addCriterion("Postcode not between", value1, value2, "postcode");
            return (Criteria) this;
        }

        public Criteria andAddressIsNull() {
            addCriterion("Address is null");
            return (Criteria) this;
        }

        public Criteria andAddressIsNotNull() {
            addCriterion("Address is not null");
            return (Criteria) this;
        }

        public Criteria andAddressEqualTo(String value) {
            addCriterion("Address =", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotEqualTo(String value) {
            addCriterion("Address <>", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThan(String value) {
            addCriterion("Address >", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThanOrEqualTo(String value) {
            addCriterion("Address >=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThan(String value) {
            addCriterion("Address <", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThanOrEqualTo(String value) {
            addCriterion("Address <=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLike(String value) {
            addCriterion("Address like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotLike(String value) {
            addCriterion("Address not like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressIn(List<String> values) {
            addCriterion("Address in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotIn(List<String> values) {
            addCriterion("Address not in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressBetween(String value1, String value2) {
            addCriterion("Address between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotBetween(String value1, String value2) {
            addCriterion("Address not between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andOrdertimeIsNull() {
            addCriterion("OrderTime is null");
            return (Criteria) this;
        }

        public Criteria andOrdertimeIsNotNull() {
            addCriterion("OrderTime is not null");
            return (Criteria) this;
        }

        public Criteria andOrdertimeEqualTo(Date value) {
            addCriterion("OrderTime =", value, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeNotEqualTo(Date value) {
            addCriterion("OrderTime <>", value, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeGreaterThan(Date value) {
            addCriterion("OrderTime >", value, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeGreaterThanOrEqualTo(Date value) {
            addCriterion("OrderTime >=", value, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeLessThan(Date value) {
            addCriterion("OrderTime <", value, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeLessThanOrEqualTo(Date value) {
            addCriterion("OrderTime <=", value, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeIn(List<Date> values) {
            addCriterion("OrderTime in", values, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeNotIn(List<Date> values) {
            addCriterion("OrderTime not in", values, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeBetween(Date value1, Date value2) {
            addCriterion("OrderTime between", value1, value2, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeNotBetween(Date value1, Date value2) {
            addCriterion("OrderTime not between", value1, value2, "ordertime");
            return (Criteria) this;
        }

        public Criteria andFinishtimeIsNull() {
            addCriterion("FinishTime is null");
            return (Criteria) this;
        }

        public Criteria andFinishtimeIsNotNull() {
            addCriterion("FinishTime is not null");
            return (Criteria) this;
        }

        public Criteria andFinishtimeEqualTo(Date value) {
            addCriterion("FinishTime =", value, "finishtime");
            return (Criteria) this;
        }

        public Criteria andFinishtimeNotEqualTo(Date value) {
            addCriterion("FinishTime <>", value, "finishtime");
            return (Criteria) this;
        }

        public Criteria andFinishtimeGreaterThan(Date value) {
            addCriterion("FinishTime >", value, "finishtime");
            return (Criteria) this;
        }

        public Criteria andFinishtimeGreaterThanOrEqualTo(Date value) {
            addCriterion("FinishTime >=", value, "finishtime");
            return (Criteria) this;
        }

        public Criteria andFinishtimeLessThan(Date value) {
            addCriterion("FinishTime <", value, "finishtime");
            return (Criteria) this;
        }

        public Criteria andFinishtimeLessThanOrEqualTo(Date value) {
            addCriterion("FinishTime <=", value, "finishtime");
            return (Criteria) this;
        }

        public Criteria andFinishtimeIn(List<Date> values) {
            addCriterion("FinishTime in", values, "finishtime");
            return (Criteria) this;
        }

        public Criteria andFinishtimeNotIn(List<Date> values) {
            addCriterion("FinishTime not in", values, "finishtime");
            return (Criteria) this;
        }

        public Criteria andFinishtimeBetween(Date value1, Date value2) {
            addCriterion("FinishTime between", value1, value2, "finishtime");
            return (Criteria) this;
        }

        public Criteria andFinishtimeNotBetween(Date value1, Date value2) {
            addCriterion("FinishTime not between", value1, value2, "finishtime");
            return (Criteria) this;
        }

        public Criteria andDiscountIsNull() {
            addCriterion("discount is null");
            return (Criteria) this;
        }

        public Criteria andDiscountIsNotNull() {
            addCriterion("discount is not null");
            return (Criteria) this;
        }

        public Criteria andDiscountEqualTo(BigDecimal value) {
            addCriterion("discount =", value, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountNotEqualTo(BigDecimal value) {
            addCriterion("discount <>", value, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountGreaterThan(BigDecimal value) {
            addCriterion("discount >", value, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("discount >=", value, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountLessThan(BigDecimal value) {
            addCriterion("discount <", value, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("discount <=", value, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountIn(List<BigDecimal> values) {
            addCriterion("discount in", values, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountNotIn(List<BigDecimal> values) {
            addCriterion("discount not in", values, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("discount between", value1, value2, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("discount not between", value1, value2, "discount");
            return (Criteria) this;
        }

        public Criteria andCommentIsNull() {
            addCriterion("comment is null");
            return (Criteria) this;
        }

        public Criteria andCommentIsNotNull() {
            addCriterion("comment is not null");
            return (Criteria) this;
        }

        public Criteria andCommentEqualTo(String value) {
            addCriterion("comment =", value, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentNotEqualTo(String value) {
            addCriterion("comment <>", value, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentGreaterThan(String value) {
            addCriterion("comment >", value, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentGreaterThanOrEqualTo(String value) {
            addCriterion("comment >=", value, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentLessThan(String value) {
            addCriterion("comment <", value, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentLessThanOrEqualTo(String value) {
            addCriterion("comment <=", value, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentLike(String value) {
            addCriterion("comment like", value, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentNotLike(String value) {
            addCriterion("comment not like", value, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentIn(List<String> values) {
            addCriterion("comment in", values, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentNotIn(List<String> values) {
            addCriterion("comment not in", values, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentBetween(String value1, String value2) {
            addCriterion("comment between", value1, value2, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentNotBetween(String value1, String value2) {
            addCriterion("comment not between", value1, value2, "comment");
            return (Criteria) this;
        }

        public Criteria andCouponidIsNull() {
            addCriterion("couponid is null");
            return (Criteria) this;
        }

        public Criteria andCouponidIsNotNull() {
            addCriterion("couponid is not null");
            return (Criteria) this;
        }

        public Criteria andCouponidEqualTo(Long value) {
            addCriterion("couponid =", value, "couponid");
            return (Criteria) this;
        }

        public Criteria andCouponidNotEqualTo(Long value) {
            addCriterion("couponid <>", value, "couponid");
            return (Criteria) this;
        }

        public Criteria andCouponidGreaterThan(Long value) {
            addCriterion("couponid >", value, "couponid");
            return (Criteria) this;
        }

        public Criteria andCouponidGreaterThanOrEqualTo(Long value) {
            addCriterion("couponid >=", value, "couponid");
            return (Criteria) this;
        }

        public Criteria andCouponidLessThan(Long value) {
            addCriterion("couponid <", value, "couponid");
            return (Criteria) this;
        }

        public Criteria andCouponidLessThanOrEqualTo(Long value) {
            addCriterion("couponid <=", value, "couponid");
            return (Criteria) this;
        }

        public Criteria andCouponidIn(List<Long> values) {
            addCriterion("couponid in", values, "couponid");
            return (Criteria) this;
        }

        public Criteria andCouponidNotIn(List<Long> values) {
            addCriterion("couponid not in", values, "couponid");
            return (Criteria) this;
        }

        public Criteria andCouponidBetween(Long value1, Long value2) {
            addCriterion("couponid between", value1, value2, "couponid");
            return (Criteria) this;
        }

        public Criteria andCouponidNotBetween(Long value1, Long value2) {
            addCriterion("couponid not between", value1, value2, "couponid");
            return (Criteria) this;
        }

        public Criteria andCouponmoneyIsNull() {
            addCriterion("couponMoney is null");
            return (Criteria) this;
        }

        public Criteria andCouponmoneyIsNotNull() {
            addCriterion("couponMoney is not null");
            return (Criteria) this;
        }

        public Criteria andCouponmoneyEqualTo(BigDecimal value) {
            addCriterion("couponMoney =", value, "couponmoney");
            return (Criteria) this;
        }

        public Criteria andCouponmoneyNotEqualTo(BigDecimal value) {
            addCriterion("couponMoney <>", value, "couponmoney");
            return (Criteria) this;
        }

        public Criteria andCouponmoneyGreaterThan(BigDecimal value) {
            addCriterion("couponMoney >", value, "couponmoney");
            return (Criteria) this;
        }

        public Criteria andCouponmoneyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("couponMoney >=", value, "couponmoney");
            return (Criteria) this;
        }

        public Criteria andCouponmoneyLessThan(BigDecimal value) {
            addCriterion("couponMoney <", value, "couponmoney");
            return (Criteria) this;
        }

        public Criteria andCouponmoneyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("couponMoney <=", value, "couponmoney");
            return (Criteria) this;
        }

        public Criteria andCouponmoneyIn(List<BigDecimal> values) {
            addCriterion("couponMoney in", values, "couponmoney");
            return (Criteria) this;
        }

        public Criteria andCouponmoneyNotIn(List<BigDecimal> values) {
            addCriterion("couponMoney not in", values, "couponmoney");
            return (Criteria) this;
        }

        public Criteria andCouponmoneyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("couponMoney between", value1, value2, "couponmoney");
            return (Criteria) this;
        }

        public Criteria andCouponmoneyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("couponMoney not between", value1, value2, "couponmoney");
            return (Criteria) this;
        }

        public Criteria andPayablemenoyIsNull() {
            addCriterion("payableMenoy is null");
            return (Criteria) this;
        }

        public Criteria andPayablemenoyIsNotNull() {
            addCriterion("payableMenoy is not null");
            return (Criteria) this;
        }

        public Criteria andPayablemenoyEqualTo(BigDecimal value) {
            addCriterion("payableMenoy =", value, "payablemenoy");
            return (Criteria) this;
        }

        public Criteria andPayablemenoyNotEqualTo(BigDecimal value) {
            addCriterion("payableMenoy <>", value, "payablemenoy");
            return (Criteria) this;
        }

        public Criteria andPayablemenoyGreaterThan(BigDecimal value) {
            addCriterion("payableMenoy >", value, "payablemenoy");
            return (Criteria) this;
        }

        public Criteria andPayablemenoyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("payableMenoy >=", value, "payablemenoy");
            return (Criteria) this;
        }

        public Criteria andPayablemenoyLessThan(BigDecimal value) {
            addCriterion("payableMenoy <", value, "payablemenoy");
            return (Criteria) this;
        }

        public Criteria andPayablemenoyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("payableMenoy <=", value, "payablemenoy");
            return (Criteria) this;
        }

        public Criteria andPayablemenoyIn(List<BigDecimal> values) {
            addCriterion("payableMenoy in", values, "payablemenoy");
            return (Criteria) this;
        }

        public Criteria andPayablemenoyNotIn(List<BigDecimal> values) {
            addCriterion("payableMenoy not in", values, "payablemenoy");
            return (Criteria) this;
        }

        public Criteria andPayablemenoyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("payableMenoy between", value1, value2, "payablemenoy");
            return (Criteria) this;
        }

        public Criteria andPayablemenoyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("payableMenoy not between", value1, value2, "payablemenoy");
            return (Criteria) this;
        }

        public Criteria andActuallypaymenyoyIsNull() {
            addCriterion("actuallyPayMenyoy is null");
            return (Criteria) this;
        }

        public Criteria andActuallypaymenyoyIsNotNull() {
            addCriterion("actuallyPayMenyoy is not null");
            return (Criteria) this;
        }

        public Criteria andActuallypaymenyoyEqualTo(BigDecimal value) {
            addCriterion("actuallyPayMenyoy =", value, "actuallypaymenyoy");
            return (Criteria) this;
        }

        public Criteria andActuallypaymenyoyNotEqualTo(BigDecimal value) {
            addCriterion("actuallyPayMenyoy <>", value, "actuallypaymenyoy");
            return (Criteria) this;
        }

        public Criteria andActuallypaymenyoyGreaterThan(BigDecimal value) {
            addCriterion("actuallyPayMenyoy >", value, "actuallypaymenyoy");
            return (Criteria) this;
        }

        public Criteria andActuallypaymenyoyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("actuallyPayMenyoy >=", value, "actuallypaymenyoy");
            return (Criteria) this;
        }

        public Criteria andActuallypaymenyoyLessThan(BigDecimal value) {
            addCriterion("actuallyPayMenyoy <", value, "actuallypaymenyoy");
            return (Criteria) this;
        }

        public Criteria andActuallypaymenyoyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("actuallyPayMenyoy <=", value, "actuallypaymenyoy");
            return (Criteria) this;
        }

        public Criteria andActuallypaymenyoyIn(List<BigDecimal> values) {
            addCriterion("actuallyPayMenyoy in", values, "actuallypaymenyoy");
            return (Criteria) this;
        }

        public Criteria andActuallypaymenyoyNotIn(List<BigDecimal> values) {
            addCriterion("actuallyPayMenyoy not in", values, "actuallypaymenyoy");
            return (Criteria) this;
        }

        public Criteria andActuallypaymenyoyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("actuallyPayMenyoy between", value1, value2, "actuallypaymenyoy");
            return (Criteria) this;
        }

        public Criteria andActuallypaymenyoyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("actuallyPayMenyoy not between", value1, value2, "actuallypaymenyoy");
            return (Criteria) this;
        }

        public Criteria andVersionIsNull() {
            addCriterion("version is null");
            return (Criteria) this;
        }

        public Criteria andVersionIsNotNull() {
            addCriterion("version is not null");
            return (Criteria) this;
        }

        public Criteria andVersionEqualTo(Integer value) {
            addCriterion("version =", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionNotEqualTo(Integer value) {
            addCriterion("version <>", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionGreaterThan(Integer value) {
            addCriterion("version >", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionGreaterThanOrEqualTo(Integer value) {
            addCriterion("version >=", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionLessThan(Integer value) {
            addCriterion("version <", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionLessThanOrEqualTo(Integer value) {
            addCriterion("version <=", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionIn(List<Integer> values) {
            addCriterion("version in", values, "version");
            return (Criteria) this;
        }

        public Criteria andVersionNotIn(List<Integer> values) {
            addCriterion("version not in", values, "version");
            return (Criteria) this;
        }

        public Criteria andVersionBetween(Integer value1, Integer value2) {
            addCriterion("version between", value1, value2, "version");
            return (Criteria) this;
        }

        public Criteria andVersionNotBetween(Integer value1, Integer value2) {
            addCriterion("version not between", value1, value2, "version");
            return (Criteria) this;
        }

        public Criteria andDeleteFlagIsNull() {
            addCriterion("delete_flag is null");
            return (Criteria) this;
        }

        public Criteria andDeleteFlagIsNotNull() {
            addCriterion("delete_flag is not null");
            return (Criteria) this;
        }

        public Criteria andDeleteFlagEqualTo(Byte value) {
            addCriterion("delete_flag =", value, "deleteFlag");
            return (Criteria) this;
        }

        public Criteria andDeleteFlagNotEqualTo(Byte value) {
            addCriterion("delete_flag <>", value, "deleteFlag");
            return (Criteria) this;
        }

        public Criteria andDeleteFlagGreaterThan(Byte value) {
            addCriterion("delete_flag >", value, "deleteFlag");
            return (Criteria) this;
        }

        public Criteria andDeleteFlagGreaterThanOrEqualTo(Byte value) {
            addCriterion("delete_flag >=", value, "deleteFlag");
            return (Criteria) this;
        }

        public Criteria andDeleteFlagLessThan(Byte value) {
            addCriterion("delete_flag <", value, "deleteFlag");
            return (Criteria) this;
        }

        public Criteria andDeleteFlagLessThanOrEqualTo(Byte value) {
            addCriterion("delete_flag <=", value, "deleteFlag");
            return (Criteria) this;
        }

        public Criteria andDeleteFlagIn(List<Byte> values) {
            addCriterion("delete_flag in", values, "deleteFlag");
            return (Criteria) this;
        }

        public Criteria andDeleteFlagNotIn(List<Byte> values) {
            addCriterion("delete_flag not in", values, "deleteFlag");
            return (Criteria) this;
        }

        public Criteria andDeleteFlagBetween(Byte value1, Byte value2) {
            addCriterion("delete_flag between", value1, value2, "deleteFlag");
            return (Criteria) this;
        }

        public Criteria andDeleteFlagNotBetween(Byte value1, Byte value2) {
            addCriterion("delete_flag not between", value1, value2, "deleteFlag");
            return (Criteria) this;
        }

        public Criteria andIsserviceIsNull() {
            addCriterion("isService is null");
            return (Criteria) this;
        }

        public Criteria andIsserviceIsNotNull() {
            addCriterion("isService is not null");
            return (Criteria) this;
        }

        public Criteria andIsserviceEqualTo(Integer value) {
            addCriterion("isService =", value, "isservice");
            return (Criteria) this;
        }

        public Criteria andIsserviceNotEqualTo(Integer value) {
            addCriterion("isService <>", value, "isservice");
            return (Criteria) this;
        }

        public Criteria andIsserviceGreaterThan(Integer value) {
            addCriterion("isService >", value, "isservice");
            return (Criteria) this;
        }

        public Criteria andIsserviceGreaterThanOrEqualTo(Integer value) {
            addCriterion("isService >=", value, "isservice");
            return (Criteria) this;
        }

        public Criteria andIsserviceLessThan(Integer value) {
            addCriterion("isService <", value, "isservice");
            return (Criteria) this;
        }

        public Criteria andIsserviceLessThanOrEqualTo(Integer value) {
            addCriterion("isService <=", value, "isservice");
            return (Criteria) this;
        }

        public Criteria andIsserviceIn(List<Integer> values) {
            addCriterion("isService in", values, "isservice");
            return (Criteria) this;
        }

        public Criteria andIsserviceNotIn(List<Integer> values) {
            addCriterion("isService not in", values, "isservice");
            return (Criteria) this;
        }

        public Criteria andIsserviceBetween(Integer value1, Integer value2) {
            addCriterion("isService between", value1, value2, "isservice");
            return (Criteria) this;
        }

        public Criteria andIsserviceNotBetween(Integer value1, Integer value2) {
            addCriterion("isService not between", value1, value2, "isservice");
            return (Criteria) this;
        }

        public Criteria andPaytimeIsNull() {
            addCriterion("payTime is null");
            return (Criteria) this;
        }

        public Criteria andPaytimeIsNotNull() {
            addCriterion("payTime is not null");
            return (Criteria) this;
        }

        public Criteria andPaytimeEqualTo(Date value) {
            addCriterion("payTime =", value, "paytime");
            return (Criteria) this;
        }

        public Criteria andPaytimeNotEqualTo(Date value) {
            addCriterion("payTime <>", value, "paytime");
            return (Criteria) this;
        }

        public Criteria andPaytimeGreaterThan(Date value) {
            addCriterion("payTime >", value, "paytime");
            return (Criteria) this;
        }

        public Criteria andPaytimeGreaterThanOrEqualTo(Date value) {
            addCriterion("payTime >=", value, "paytime");
            return (Criteria) this;
        }

        public Criteria andPaytimeLessThan(Date value) {
            addCriterion("payTime <", value, "paytime");
            return (Criteria) this;
        }

        public Criteria andPaytimeLessThanOrEqualTo(Date value) {
            addCriterion("payTime <=", value, "paytime");
            return (Criteria) this;
        }

        public Criteria andPaytimeIn(List<Date> values) {
            addCriterion("payTime in", values, "paytime");
            return (Criteria) this;
        }

        public Criteria andPaytimeNotIn(List<Date> values) {
            addCriterion("payTime not in", values, "paytime");
            return (Criteria) this;
        }

        public Criteria andPaytimeBetween(Date value1, Date value2) {
            addCriterion("payTime between", value1, value2, "paytime");
            return (Criteria) this;
        }

        public Criteria andPaytimeNotBetween(Date value1, Date value2) {
            addCriterion("payTime not between", value1, value2, "paytime");
            return (Criteria) this;
        }

        public Criteria andExpectsendtimeIsNull() {
            addCriterion("expectSendTime is null");
            return (Criteria) this;
        }

        public Criteria andExpectsendtimeIsNotNull() {
            addCriterion("expectSendTime is not null");
            return (Criteria) this;
        }

        public Criteria andExpectsendtimeEqualTo(Date value) {
            addCriterion("expectSendTime =", value, "expectsendtime");
            return (Criteria) this;
        }

        public Criteria andExpectsendtimeNotEqualTo(Date value) {
            addCriterion("expectSendTime <>", value, "expectsendtime");
            return (Criteria) this;
        }

        public Criteria andExpectsendtimeGreaterThan(Date value) {
            addCriterion("expectSendTime >", value, "expectsendtime");
            return (Criteria) this;
        }

        public Criteria andExpectsendtimeGreaterThanOrEqualTo(Date value) {
            addCriterion("expectSendTime >=", value, "expectsendtime");
            return (Criteria) this;
        }

        public Criteria andExpectsendtimeLessThan(Date value) {
            addCriterion("expectSendTime <", value, "expectsendtime");
            return (Criteria) this;
        }

        public Criteria andExpectsendtimeLessThanOrEqualTo(Date value) {
            addCriterion("expectSendTime <=", value, "expectsendtime");
            return (Criteria) this;
        }

        public Criteria andExpectsendtimeIn(List<Date> values) {
            addCriterion("expectSendTime in", values, "expectsendtime");
            return (Criteria) this;
        }

        public Criteria andExpectsendtimeNotIn(List<Date> values) {
            addCriterion("expectSendTime not in", values, "expectsendtime");
            return (Criteria) this;
        }

        public Criteria andExpectsendtimeBetween(Date value1, Date value2) {
            addCriterion("expectSendTime between", value1, value2, "expectsendtime");
            return (Criteria) this;
        }

        public Criteria andExpectsendtimeNotBetween(Date value1, Date value2) {
            addCriterion("expectSendTime not between", value1, value2, "expectsendtime");
            return (Criteria) this;
        }

        public Criteria andActualsendtimeIsNull() {
            addCriterion("actualSendTime is null");
            return (Criteria) this;
        }

        public Criteria andActualsendtimeIsNotNull() {
            addCriterion("actualSendTime is not null");
            return (Criteria) this;
        }

        public Criteria andActualsendtimeEqualTo(Date value) {
            addCriterion("actualSendTime =", value, "actualsendtime");
            return (Criteria) this;
        }

        public Criteria andActualsendtimeNotEqualTo(Date value) {
            addCriterion("actualSendTime <>", value, "actualsendtime");
            return (Criteria) this;
        }

        public Criteria andActualsendtimeGreaterThan(Date value) {
            addCriterion("actualSendTime >", value, "actualsendtime");
            return (Criteria) this;
        }

        public Criteria andActualsendtimeGreaterThanOrEqualTo(Date value) {
            addCriterion("actualSendTime >=", value, "actualsendtime");
            return (Criteria) this;
        }

        public Criteria andActualsendtimeLessThan(Date value) {
            addCriterion("actualSendTime <", value, "actualsendtime");
            return (Criteria) this;
        }

        public Criteria andActualsendtimeLessThanOrEqualTo(Date value) {
            addCriterion("actualSendTime <=", value, "actualsendtime");
            return (Criteria) this;
        }

        public Criteria andActualsendtimeIn(List<Date> values) {
            addCriterion("actualSendTime in", values, "actualsendtime");
            return (Criteria) this;
        }

        public Criteria andActualsendtimeNotIn(List<Date> values) {
            addCriterion("actualSendTime not in", values, "actualsendtime");
            return (Criteria) this;
        }

        public Criteria andActualsendtimeBetween(Date value1, Date value2) {
            addCriterion("actualSendTime between", value1, value2, "actualsendtime");
            return (Criteria) this;
        }

        public Criteria andActualsendtimeNotBetween(Date value1, Date value2) {
            addCriterion("actualSendTime not between", value1, value2, "actualsendtime");
            return (Criteria) this;
        }

        public Criteria andNeedboxIsNull() {
            addCriterion("needBox is null");
            return (Criteria) this;
        }

        public Criteria andNeedboxIsNotNull() {
            addCriterion("needBox is not null");
            return (Criteria) this;
        }

        public Criteria andNeedboxEqualTo(Integer value) {
            addCriterion("needBox =", value, "needbox");
            return (Criteria) this;
        }

        public Criteria andNeedboxNotEqualTo(Integer value) {
            addCriterion("needBox <>", value, "needbox");
            return (Criteria) this;
        }

        public Criteria andNeedboxGreaterThan(Integer value) {
            addCriterion("needBox >", value, "needbox");
            return (Criteria) this;
        }

        public Criteria andNeedboxGreaterThanOrEqualTo(Integer value) {
            addCriterion("needBox >=", value, "needbox");
            return (Criteria) this;
        }

        public Criteria andNeedboxLessThan(Integer value) {
            addCriterion("needBox <", value, "needbox");
            return (Criteria) this;
        }

        public Criteria andNeedboxLessThanOrEqualTo(Integer value) {
            addCriterion("needBox <=", value, "needbox");
            return (Criteria) this;
        }

        public Criteria andNeedboxIn(List<Integer> values) {
            addCriterion("needBox in", values, "needbox");
            return (Criteria) this;
        }

        public Criteria andNeedboxNotIn(List<Integer> values) {
            addCriterion("needBox not in", values, "needbox");
            return (Criteria) this;
        }

        public Criteria andNeedboxBetween(Integer value1, Integer value2) {
            addCriterion("needBox between", value1, value2, "needbox");
            return (Criteria) this;
        }

        public Criteria andNeedboxNotBetween(Integer value1, Integer value2) {
            addCriterion("needBox not between", value1, value2, "needbox");
            return (Criteria) this;
        }

        public Criteria andNeedbagIsNull() {
            addCriterion("needBag is null");
            return (Criteria) this;
        }

        public Criteria andNeedbagIsNotNull() {
            addCriterion("needBag is not null");
            return (Criteria) this;
        }

        public Criteria andNeedbagEqualTo(Integer value) {
            addCriterion("needBag =", value, "needbag");
            return (Criteria) this;
        }

        public Criteria andNeedbagNotEqualTo(Integer value) {
            addCriterion("needBag <>", value, "needbag");
            return (Criteria) this;
        }

        public Criteria andNeedbagGreaterThan(Integer value) {
            addCriterion("needBag >", value, "needbag");
            return (Criteria) this;
        }

        public Criteria andNeedbagGreaterThanOrEqualTo(Integer value) {
            addCriterion("needBag >=", value, "needbag");
            return (Criteria) this;
        }

        public Criteria andNeedbagLessThan(Integer value) {
            addCriterion("needBag <", value, "needbag");
            return (Criteria) this;
        }

        public Criteria andNeedbagLessThanOrEqualTo(Integer value) {
            addCriterion("needBag <=", value, "needbag");
            return (Criteria) this;
        }

        public Criteria andNeedbagIn(List<Integer> values) {
            addCriterion("needBag in", values, "needbag");
            return (Criteria) this;
        }

        public Criteria andNeedbagNotIn(List<Integer> values) {
            addCriterion("needBag not in", values, "needbag");
            return (Criteria) this;
        }

        public Criteria andNeedbagBetween(Integer value1, Integer value2) {
            addCriterion("needBag between", value1, value2, "needbag");
            return (Criteria) this;
        }

        public Criteria andNeedbagNotBetween(Integer value1, Integer value2) {
            addCriterion("needBag not between", value1, value2, "needbag");
            return (Criteria) this;
        }

        public Criteria andBanktypeIsNull() {
            addCriterion("bankType is null");
            return (Criteria) this;
        }

        public Criteria andBanktypeIsNotNull() {
            addCriterion("bankType is not null");
            return (Criteria) this;
        }

        public Criteria andBanktypeEqualTo(String value) {
            addCriterion("bankType =", value, "banktype");
            return (Criteria) this;
        }

        public Criteria andBanktypeNotEqualTo(String value) {
            addCriterion("bankType <>", value, "banktype");
            return (Criteria) this;
        }

        public Criteria andBanktypeGreaterThan(String value) {
            addCriterion("bankType >", value, "banktype");
            return (Criteria) this;
        }

        public Criteria andBanktypeGreaterThanOrEqualTo(String value) {
            addCriterion("bankType >=", value, "banktype");
            return (Criteria) this;
        }

        public Criteria andBanktypeLessThan(String value) {
            addCriterion("bankType <", value, "banktype");
            return (Criteria) this;
        }

        public Criteria andBanktypeLessThanOrEqualTo(String value) {
            addCriterion("bankType <=", value, "banktype");
            return (Criteria) this;
        }

        public Criteria andBanktypeLike(String value) {
            addCriterion("bankType like", value, "banktype");
            return (Criteria) this;
        }

        public Criteria andBanktypeNotLike(String value) {
            addCriterion("bankType not like", value, "banktype");
            return (Criteria) this;
        }

        public Criteria andBanktypeIn(List<String> values) {
            addCriterion("bankType in", values, "banktype");
            return (Criteria) this;
        }

        public Criteria andBanktypeNotIn(List<String> values) {
            addCriterion("bankType not in", values, "banktype");
            return (Criteria) this;
        }

        public Criteria andBanktypeBetween(String value1, String value2) {
            addCriterion("bankType between", value1, value2, "banktype");
            return (Criteria) this;
        }

        public Criteria andBanktypeNotBetween(String value1, String value2) {
            addCriterion("bankType not between", value1, value2, "banktype");
            return (Criteria) this;
        }

        public Criteria andLogisticsstatusIsNull() {
            addCriterion("logisticsStatus is null");
            return (Criteria) this;
        }

        public Criteria andLogisticsstatusIsNotNull() {
            addCriterion("logisticsStatus is not null");
            return (Criteria) this;
        }

        public Criteria andLogisticsstatusEqualTo(Integer value) {
            addCriterion("logisticsStatus =", value, "logisticsstatus");
            return (Criteria) this;
        }

        public Criteria andLogisticsstatusNotEqualTo(Integer value) {
            addCriterion("logisticsStatus <>", value, "logisticsstatus");
            return (Criteria) this;
        }

        public Criteria andLogisticsstatusGreaterThan(Integer value) {
            addCriterion("logisticsStatus >", value, "logisticsstatus");
            return (Criteria) this;
        }

        public Criteria andLogisticsstatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("logisticsStatus >=", value, "logisticsstatus");
            return (Criteria) this;
        }

        public Criteria andLogisticsstatusLessThan(Integer value) {
            addCriterion("logisticsStatus <", value, "logisticsstatus");
            return (Criteria) this;
        }

        public Criteria andLogisticsstatusLessThanOrEqualTo(Integer value) {
            addCriterion("logisticsStatus <=", value, "logisticsstatus");
            return (Criteria) this;
        }

        public Criteria andLogisticsstatusIn(List<Integer> values) {
            addCriterion("logisticsStatus in", values, "logisticsstatus");
            return (Criteria) this;
        }

        public Criteria andLogisticsstatusNotIn(List<Integer> values) {
            addCriterion("logisticsStatus not in", values, "logisticsstatus");
            return (Criteria) this;
        }

        public Criteria andLogisticsstatusBetween(Integer value1, Integer value2) {
            addCriterion("logisticsStatus between", value1, value2, "logisticsstatus");
            return (Criteria) this;
        }

        public Criteria andLogisticsstatusNotBetween(Integer value1, Integer value2) {
            addCriterion("logisticsStatus not between", value1, value2, "logisticsstatus");
            return (Criteria) this;
        }

        public Criteria andEmsidIsNull() {
            addCriterion("EMSID is null");
            return (Criteria) this;
        }

        public Criteria andEmsidIsNotNull() {
            addCriterion("EMSID is not null");
            return (Criteria) this;
        }

        public Criteria andEmsidEqualTo(Integer value) {
            addCriterion("EMSID =", value, "emsid");
            return (Criteria) this;
        }

        public Criteria andEmsidNotEqualTo(Integer value) {
            addCriterion("EMSID <>", value, "emsid");
            return (Criteria) this;
        }

        public Criteria andEmsidGreaterThan(Integer value) {
            addCriterion("EMSID >", value, "emsid");
            return (Criteria) this;
        }

        public Criteria andEmsidGreaterThanOrEqualTo(Integer value) {
            addCriterion("EMSID >=", value, "emsid");
            return (Criteria) this;
        }

        public Criteria andEmsidLessThan(Integer value) {
            addCriterion("EMSID <", value, "emsid");
            return (Criteria) this;
        }

        public Criteria andEmsidLessThanOrEqualTo(Integer value) {
            addCriterion("EMSID <=", value, "emsid");
            return (Criteria) this;
        }

        public Criteria andEmsidIn(List<Integer> values) {
            addCriterion("EMSID in", values, "emsid");
            return (Criteria) this;
        }

        public Criteria andEmsidNotIn(List<Integer> values) {
            addCriterion("EMSID not in", values, "emsid");
            return (Criteria) this;
        }

        public Criteria andEmsidBetween(Integer value1, Integer value2) {
            addCriterion("EMSID between", value1, value2, "emsid");
            return (Criteria) this;
        }

        public Criteria andEmsidNotBetween(Integer value1, Integer value2) {
            addCriterion("EMSID not between", value1, value2, "emsid");
            return (Criteria) this;
        }

        public Criteria andRemindconsignmentIsNull() {
            addCriterion("remindConsignment is null");
            return (Criteria) this;
        }

        public Criteria andRemindconsignmentIsNotNull() {
            addCriterion("remindConsignment is not null");
            return (Criteria) this;
        }

        public Criteria andRemindconsignmentEqualTo(Integer value) {
            addCriterion("remindConsignment =", value, "remindconsignment");
            return (Criteria) this;
        }

        public Criteria andRemindconsignmentNotEqualTo(Integer value) {
            addCriterion("remindConsignment <>", value, "remindconsignment");
            return (Criteria) this;
        }

        public Criteria andRemindconsignmentGreaterThan(Integer value) {
            addCriterion("remindConsignment >", value, "remindconsignment");
            return (Criteria) this;
        }

        public Criteria andRemindconsignmentGreaterThanOrEqualTo(Integer value) {
            addCriterion("remindConsignment >=", value, "remindconsignment");
            return (Criteria) this;
        }

        public Criteria andRemindconsignmentLessThan(Integer value) {
            addCriterion("remindConsignment <", value, "remindconsignment");
            return (Criteria) this;
        }

        public Criteria andRemindconsignmentLessThanOrEqualTo(Integer value) {
            addCriterion("remindConsignment <=", value, "remindconsignment");
            return (Criteria) this;
        }

        public Criteria andRemindconsignmentIn(List<Integer> values) {
            addCriterion("remindConsignment in", values, "remindconsignment");
            return (Criteria) this;
        }

        public Criteria andRemindconsignmentNotIn(List<Integer> values) {
            addCriterion("remindConsignment not in", values, "remindconsignment");
            return (Criteria) this;
        }

        public Criteria andRemindconsignmentBetween(Integer value1, Integer value2) {
            addCriterion("remindConsignment between", value1, value2, "remindconsignment");
            return (Criteria) this;
        }

        public Criteria andRemindconsignmentNotBetween(Integer value1, Integer value2) {
            addCriterion("remindConsignment not between", value1, value2, "remindconsignment");
            return (Criteria) this;
        }

        public Criteria andAstrictpaytimeIsNull() {
            addCriterion("astrictPayTime is null");
            return (Criteria) this;
        }

        public Criteria andAstrictpaytimeIsNotNull() {
            addCriterion("astrictPayTime is not null");
            return (Criteria) this;
        }

        public Criteria andAstrictpaytimeEqualTo(Date value) {
            addCriterion("astrictPayTime =", value, "astrictpaytime");
            return (Criteria) this;
        }

        public Criteria andAstrictpaytimeNotEqualTo(Date value) {
            addCriterion("astrictPayTime <>", value, "astrictpaytime");
            return (Criteria) this;
        }

        public Criteria andAstrictpaytimeGreaterThan(Date value) {
            addCriterion("astrictPayTime >", value, "astrictpaytime");
            return (Criteria) this;
        }

        public Criteria andAstrictpaytimeGreaterThanOrEqualTo(Date value) {
            addCriterion("astrictPayTime >=", value, "astrictpaytime");
            return (Criteria) this;
        }

        public Criteria andAstrictpaytimeLessThan(Date value) {
            addCriterion("astrictPayTime <", value, "astrictpaytime");
            return (Criteria) this;
        }

        public Criteria andAstrictpaytimeLessThanOrEqualTo(Date value) {
            addCriterion("astrictPayTime <=", value, "astrictpaytime");
            return (Criteria) this;
        }

        public Criteria andAstrictpaytimeIn(List<Date> values) {
            addCriterion("astrictPayTime in", values, "astrictpaytime");
            return (Criteria) this;
        }

        public Criteria andAstrictpaytimeNotIn(List<Date> values) {
            addCriterion("astrictPayTime not in", values, "astrictpaytime");
            return (Criteria) this;
        }

        public Criteria andAstrictpaytimeBetween(Date value1, Date value2) {
            addCriterion("astrictPayTime between", value1, value2, "astrictpaytime");
            return (Criteria) this;
        }

        public Criteria andAstrictpaytimeNotBetween(Date value1, Date value2) {
            addCriterion("astrictPayTime not between", value1, value2, "astrictpaytime");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNull() {
            addCriterion("remark is null");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNotNull() {
            addCriterion("remark is not null");
            return (Criteria) this;
        }

        public Criteria andRemarkEqualTo(String value) {
            addCriterion("remark =", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotEqualTo(String value) {
            addCriterion("remark <>", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThan(String value) {
            addCriterion("remark >", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("remark >=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThan(String value) {
            addCriterion("remark <", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThanOrEqualTo(String value) {
            addCriterion("remark <=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLike(String value) {
            addCriterion("remark like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotLike(String value) {
            addCriterion("remark not like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkIn(List<String> values) {
            addCriterion("remark in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotIn(List<String> values) {
            addCriterion("remark not in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkBetween(String value1, String value2) {
            addCriterion("remark between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotBetween(String value1, String value2) {
            addCriterion("remark not between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andPaystyleIsNull() {
            addCriterion("payStyle is null");
            return (Criteria) this;
        }

        public Criteria andPaystyleIsNotNull() {
            addCriterion("payStyle is not null");
            return (Criteria) this;
        }

        public Criteria andPaystyleEqualTo(Integer value) {
            addCriterion("payStyle =", value, "paystyle");
            return (Criteria) this;
        }

        public Criteria andPaystyleNotEqualTo(Integer value) {
            addCriterion("payStyle <>", value, "paystyle");
            return (Criteria) this;
        }

        public Criteria andPaystyleGreaterThan(Integer value) {
            addCriterion("payStyle >", value, "paystyle");
            return (Criteria) this;
        }

        public Criteria andPaystyleGreaterThanOrEqualTo(Integer value) {
            addCriterion("payStyle >=", value, "paystyle");
            return (Criteria) this;
        }

        public Criteria andPaystyleLessThan(Integer value) {
            addCriterion("payStyle <", value, "paystyle");
            return (Criteria) this;
        }

        public Criteria andPaystyleLessThanOrEqualTo(Integer value) {
            addCriterion("payStyle <=", value, "paystyle");
            return (Criteria) this;
        }

        public Criteria andPaystyleIn(List<Integer> values) {
            addCriterion("payStyle in", values, "paystyle");
            return (Criteria) this;
        }

        public Criteria andPaystyleNotIn(List<Integer> values) {
            addCriterion("payStyle not in", values, "paystyle");
            return (Criteria) this;
        }

        public Criteria andPaystyleBetween(Integer value1, Integer value2) {
            addCriterion("payStyle between", value1, value2, "paystyle");
            return (Criteria) this;
        }

        public Criteria andPaystyleNotBetween(Integer value1, Integer value2) {
            addCriterion("payStyle not between", value1, value2, "paystyle");
            return (Criteria) this;
        }

        public Criteria andOperatetimedateIsNull() {
            addCriterion("operateTimeDate is null");
            return (Criteria) this;
        }

        public Criteria andOperatetimedateIsNotNull() {
            addCriterion("operateTimeDate is not null");
            return (Criteria) this;
        }

        public Criteria andOperatetimedateEqualTo(Date value) {
            addCriterion("operateTimeDate =", value, "operatetimedate");
            return (Criteria) this;
        }

        public Criteria andOperatetimedateNotEqualTo(Date value) {
            addCriterion("operateTimeDate <>", value, "operatetimedate");
            return (Criteria) this;
        }

        public Criteria andOperatetimedateGreaterThan(Date value) {
            addCriterion("operateTimeDate >", value, "operatetimedate");
            return (Criteria) this;
        }

        public Criteria andOperatetimedateGreaterThanOrEqualTo(Date value) {
            addCriterion("operateTimeDate >=", value, "operatetimedate");
            return (Criteria) this;
        }

        public Criteria andOperatetimedateLessThan(Date value) {
            addCriterion("operateTimeDate <", value, "operatetimedate");
            return (Criteria) this;
        }

        public Criteria andOperatetimedateLessThanOrEqualTo(Date value) {
            addCriterion("operateTimeDate <=", value, "operatetimedate");
            return (Criteria) this;
        }

        public Criteria andOperatetimedateIn(List<Date> values) {
            addCriterion("operateTimeDate in", values, "operatetimedate");
            return (Criteria) this;
        }

        public Criteria andOperatetimedateNotIn(List<Date> values) {
            addCriterion("operateTimeDate not in", values, "operatetimedate");
            return (Criteria) this;
        }

        public Criteria andOperatetimedateBetween(Date value1, Date value2) {
            addCriterion("operateTimeDate between", value1, value2, "operatetimedate");
            return (Criteria) this;
        }

        public Criteria andOperatetimedateNotBetween(Date value1, Date value2) {
            addCriterion("operateTimeDate not between", value1, value2, "operatetimedate");
            return (Criteria) this;
        }

        public Criteria andGoodsrejectedIsNull() {
            addCriterion("goodsRejected is null");
            return (Criteria) this;
        }

        public Criteria andGoodsrejectedIsNotNull() {
            addCriterion("goodsRejected is not null");
            return (Criteria) this;
        }

        public Criteria andGoodsrejectedEqualTo(Integer value) {
            addCriterion("goodsRejected =", value, "goodsrejected");
            return (Criteria) this;
        }

        public Criteria andGoodsrejectedNotEqualTo(Integer value) {
            addCriterion("goodsRejected <>", value, "goodsrejected");
            return (Criteria) this;
        }

        public Criteria andGoodsrejectedGreaterThan(Integer value) {
            addCriterion("goodsRejected >", value, "goodsrejected");
            return (Criteria) this;
        }

        public Criteria andGoodsrejectedGreaterThanOrEqualTo(Integer value) {
            addCriterion("goodsRejected >=", value, "goodsrejected");
            return (Criteria) this;
        }

        public Criteria andGoodsrejectedLessThan(Integer value) {
            addCriterion("goodsRejected <", value, "goodsrejected");
            return (Criteria) this;
        }

        public Criteria andGoodsrejectedLessThanOrEqualTo(Integer value) {
            addCriterion("goodsRejected <=", value, "goodsrejected");
            return (Criteria) this;
        }

        public Criteria andGoodsrejectedIn(List<Integer> values) {
            addCriterion("goodsRejected in", values, "goodsrejected");
            return (Criteria) this;
        }

        public Criteria andGoodsrejectedNotIn(List<Integer> values) {
            addCriterion("goodsRejected not in", values, "goodsrejected");
            return (Criteria) this;
        }

        public Criteria andGoodsrejectedBetween(Integer value1, Integer value2) {
            addCriterion("goodsRejected between", value1, value2, "goodsrejected");
            return (Criteria) this;
        }

        public Criteria andGoodsrejectedNotBetween(Integer value1, Integer value2) {
            addCriterion("goodsRejected not between", value1, value2, "goodsrejected");
            return (Criteria) this;
        }

        public Criteria andVipmenoyIsNull() {
            addCriterion("vipMenoy is null");
            return (Criteria) this;
        }

        public Criteria andVipmenoyIsNotNull() {
            addCriterion("vipMenoy is not null");
            return (Criteria) this;
        }

        public Criteria andVipmenoyEqualTo(BigDecimal value) {
            addCriterion("vipMenoy =", value, "vipmenoy");
            return (Criteria) this;
        }

        public Criteria andVipmenoyNotEqualTo(BigDecimal value) {
            addCriterion("vipMenoy <>", value, "vipmenoy");
            return (Criteria) this;
        }

        public Criteria andVipmenoyGreaterThan(BigDecimal value) {
            addCriterion("vipMenoy >", value, "vipmenoy");
            return (Criteria) this;
        }

        public Criteria andVipmenoyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("vipMenoy >=", value, "vipmenoy");
            return (Criteria) this;
        }

        public Criteria andVipmenoyLessThan(BigDecimal value) {
            addCriterion("vipMenoy <", value, "vipmenoy");
            return (Criteria) this;
        }

        public Criteria andVipmenoyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("vipMenoy <=", value, "vipmenoy");
            return (Criteria) this;
        }

        public Criteria andVipmenoyIn(List<BigDecimal> values) {
            addCriterion("vipMenoy in", values, "vipmenoy");
            return (Criteria) this;
        }

        public Criteria andVipmenoyNotIn(List<BigDecimal> values) {
            addCriterion("vipMenoy not in", values, "vipmenoy");
            return (Criteria) this;
        }

        public Criteria andVipmenoyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("vipMenoy between", value1, value2, "vipmenoy");
            return (Criteria) this;
        }

        public Criteria andVipmenoyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("vipMenoy not between", value1, value2, "vipmenoy");
            return (Criteria) this;
        }

        public Criteria andLogisticstypeIsNull() {
            addCriterion("logisticsType is null");
            return (Criteria) this;
        }

        public Criteria andLogisticstypeIsNotNull() {
            addCriterion("logisticsType is not null");
            return (Criteria) this;
        }

        public Criteria andLogisticstypeEqualTo(Byte value) {
            addCriterion("logisticsType =", value, "logisticstype");
            return (Criteria) this;
        }

        public Criteria andLogisticstypeNotEqualTo(Byte value) {
            addCriterion("logisticsType <>", value, "logisticstype");
            return (Criteria) this;
        }

        public Criteria andLogisticstypeGreaterThan(Byte value) {
            addCriterion("logisticsType >", value, "logisticstype");
            return (Criteria) this;
        }

        public Criteria andLogisticstypeGreaterThanOrEqualTo(Byte value) {
            addCriterion("logisticsType >=", value, "logisticstype");
            return (Criteria) this;
        }

        public Criteria andLogisticstypeLessThan(Byte value) {
            addCriterion("logisticsType <", value, "logisticstype");
            return (Criteria) this;
        }

        public Criteria andLogisticstypeLessThanOrEqualTo(Byte value) {
            addCriterion("logisticsType <=", value, "logisticstype");
            return (Criteria) this;
        }

        public Criteria andLogisticstypeIn(List<Byte> values) {
            addCriterion("logisticsType in", values, "logisticstype");
            return (Criteria) this;
        }

        public Criteria andLogisticstypeNotIn(List<Byte> values) {
            addCriterion("logisticsType not in", values, "logisticstype");
            return (Criteria) this;
        }

        public Criteria andLogisticstypeBetween(Byte value1, Byte value2) {
            addCriterion("logisticsType between", value1, value2, "logisticstype");
            return (Criteria) this;
        }

        public Criteria andLogisticstypeNotBetween(Byte value1, Byte value2) {
            addCriterion("logisticsType not between", value1, value2, "logisticstype");
            return (Criteria) this;
        }

        public Criteria andRebatemoneyIsNull() {
            addCriterion("rebateMoney is null");
            return (Criteria) this;
        }

        public Criteria andRebatemoneyIsNotNull() {
            addCriterion("rebateMoney is not null");
            return (Criteria) this;
        }

        public Criteria andRebatemoneyEqualTo(BigDecimal value) {
            addCriterion("rebateMoney =", value, "rebatemoney");
            return (Criteria) this;
        }

        public Criteria andRebatemoneyNotEqualTo(BigDecimal value) {
            addCriterion("rebateMoney <>", value, "rebatemoney");
            return (Criteria) this;
        }

        public Criteria andRebatemoneyGreaterThan(BigDecimal value) {
            addCriterion("rebateMoney >", value, "rebatemoney");
            return (Criteria) this;
        }

        public Criteria andRebatemoneyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("rebateMoney >=", value, "rebatemoney");
            return (Criteria) this;
        }

        public Criteria andRebatemoneyLessThan(BigDecimal value) {
            addCriterion("rebateMoney <", value, "rebatemoney");
            return (Criteria) this;
        }

        public Criteria andRebatemoneyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("rebateMoney <=", value, "rebatemoney");
            return (Criteria) this;
        }

        public Criteria andRebatemoneyIn(List<BigDecimal> values) {
            addCriterion("rebateMoney in", values, "rebatemoney");
            return (Criteria) this;
        }

        public Criteria andRebatemoneyNotIn(List<BigDecimal> values) {
            addCriterion("rebateMoney not in", values, "rebatemoney");
            return (Criteria) this;
        }

        public Criteria andRebatemoneyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("rebateMoney between", value1, value2, "rebatemoney");
            return (Criteria) this;
        }

        public Criteria andRebatemoneyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("rebateMoney not between", value1, value2, "rebatemoney");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}